package com.health.db.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class UserCashAccountIdNoExample extends UserCashAccountIdNo {
    /**
	 * 
	 */
	private static final long serialVersionUID = -4348904135587742426L;

	protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public UserCashAccountIdNoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andRecidIsNull() {
            addCriterion("RecID is null");
            return (Criteria) this;
        }

        public Criteria andRecidIsNotNull() {
            addCriterion("RecID is not null");
            return (Criteria) this;
        }

        public Criteria andRecidEqualTo(Long value) {
            addCriterion("RecID =", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotEqualTo(Long value) {
            addCriterion("RecID <>", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidGreaterThan(Long value) {
            addCriterion("RecID >", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidGreaterThanOrEqualTo(Long value) {
            addCriterion("RecID >=", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidLessThan(Long value) {
            addCriterion("RecID <", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidLessThanOrEqualTo(Long value) {
            addCriterion("RecID <=", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidIn(List<Long> values) {
            addCriterion("RecID in", values, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotIn(List<Long> values) {
            addCriterion("RecID not in", values, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidBetween(Long value1, Long value2) {
            addCriterion("RecID between", value1, value2, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotBetween(Long value1, Long value2) {
            addCriterion("RecID not between", value1, value2, "recid");
            return (Criteria) this;
        }

        public Criteria andSystemidIsNull() {
            addCriterion("systemID is null");
            return (Criteria) this;
        }

        public Criteria andSystemidIsNotNull() {
            addCriterion("systemID is not null");
            return (Criteria) this;
        }

        public Criteria andSystemidEqualTo(Integer value) {
            addCriterion("systemID =", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotEqualTo(Integer value) {
            addCriterion("systemID <>", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidGreaterThan(Integer value) {
            addCriterion("systemID >", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidGreaterThanOrEqualTo(Integer value) {
            addCriterion("systemID >=", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidLessThan(Integer value) {
            addCriterion("systemID <", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidLessThanOrEqualTo(Integer value) {
            addCriterion("systemID <=", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidIn(List<Integer> values) {
            addCriterion("systemID in", values, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotIn(List<Integer> values) {
            addCriterion("systemID not in", values, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidBetween(Integer value1, Integer value2) {
            addCriterion("systemID between", value1, value2, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotBetween(Integer value1, Integer value2) {
            addCriterion("systemID not between", value1, value2, "systemid");
            return (Criteria) this;
        }

        public Criteria andOwneridIsNull() {
            addCriterion("ownerID is null");
            return (Criteria) this;
        }

        public Criteria andOwneridIsNotNull() {
            addCriterion("ownerID is not null");
            return (Criteria) this;
        }

        public Criteria andOwneridEqualTo(Long value) {
            addCriterion("ownerID =", value, "ownerid");
            return (Criteria) this;
        }

        public Criteria andOwneridNotEqualTo(Long value) {
            addCriterion("ownerID <>", value, "ownerid");
            return (Criteria) this;
        }

        public Criteria andOwneridGreaterThan(Long value) {
            addCriterion("ownerID >", value, "ownerid");
            return (Criteria) this;
        }

        public Criteria andOwneridGreaterThanOrEqualTo(Long value) {
            addCriterion("ownerID >=", value, "ownerid");
            return (Criteria) this;
        }

        public Criteria andOwneridLessThan(Long value) {
            addCriterion("ownerID <", value, "ownerid");
            return (Criteria) this;
        }

        public Criteria andOwneridLessThanOrEqualTo(Long value) {
            addCriterion("ownerID <=", value, "ownerid");
            return (Criteria) this;
        }

        public Criteria andOwneridIn(List<Long> values) {
            addCriterion("ownerID in", values, "ownerid");
            return (Criteria) this;
        }

        public Criteria andOwneridNotIn(List<Long> values) {
            addCriterion("ownerID not in", values, "ownerid");
            return (Criteria) this;
        }

        public Criteria andOwneridBetween(Long value1, Long value2) {
            addCriterion("ownerID between", value1, value2, "ownerid");
            return (Criteria) this;
        }

        public Criteria andOwneridNotBetween(Long value1, Long value2) {
            addCriterion("ownerID not between", value1, value2, "ownerid");
            return (Criteria) this;
        }

        public Criteria andAccountidIsNull() {
            addCriterion("AccountID is null");
            return (Criteria) this;
        }

        public Criteria andAccountidIsNotNull() {
            addCriterion("AccountID is not null");
            return (Criteria) this;
        }

        public Criteria andAccountidEqualTo(Long value) {
            addCriterion("AccountID =", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotEqualTo(Long value) {
            addCriterion("AccountID <>", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidGreaterThan(Long value) {
            addCriterion("AccountID >", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidGreaterThanOrEqualTo(Long value) {
            addCriterion("AccountID >=", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidLessThan(Long value) {
            addCriterion("AccountID <", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidLessThanOrEqualTo(Long value) {
            addCriterion("AccountID <=", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidIn(List<Long> values) {
            addCriterion("AccountID in", values, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotIn(List<Long> values) {
            addCriterion("AccountID not in", values, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidBetween(Long value1, Long value2) {
            addCriterion("AccountID between", value1, value2, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotBetween(Long value1, Long value2) {
            addCriterion("AccountID not between", value1, value2, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameIsNull() {
            addCriterion("Account_Bank_NAME is null");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameIsNotNull() {
            addCriterion("Account_Bank_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameEqualTo(String value) {
            addCriterion("Account_Bank_NAME =", value, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameNotEqualTo(String value) {
            addCriterion("Account_Bank_NAME <>", value, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameGreaterThan(String value) {
            addCriterion("Account_Bank_NAME >", value, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("Account_Bank_NAME >=", value, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameLessThan(String value) {
            addCriterion("Account_Bank_NAME <", value, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameLessThanOrEqualTo(String value) {
            addCriterion("Account_Bank_NAME <=", value, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameLike(String value) {
            addCriterion("Account_Bank_NAME like", value, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameNotLike(String value) {
            addCriterion("Account_Bank_NAME not like", value, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameIn(List<String> values) {
            addCriterion("Account_Bank_NAME in", values, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameNotIn(List<String> values) {
            addCriterion("Account_Bank_NAME not in", values, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameBetween(String value1, String value2) {
            addCriterion("Account_Bank_NAME between", value1, value2, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountBankNameNotBetween(String value1, String value2) {
            addCriterion("Account_Bank_NAME not between", value1, value2, "accountBankName");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoIsNull() {
            addCriterion("Account_IDNO is null");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoIsNotNull() {
            addCriterion("Account_IDNO is not null");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoEqualTo(String value) {
            addCriterion("Account_IDNO =", value, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoNotEqualTo(String value) {
            addCriterion("Account_IDNO <>", value, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoGreaterThan(String value) {
            addCriterion("Account_IDNO >", value, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoGreaterThanOrEqualTo(String value) {
            addCriterion("Account_IDNO >=", value, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoLessThan(String value) {
            addCriterion("Account_IDNO <", value, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoLessThanOrEqualTo(String value) {
            addCriterion("Account_IDNO <=", value, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoLike(String value) {
            addCriterion("Account_IDNO like", value, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoNotLike(String value) {
            addCriterion("Account_IDNO not like", value, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoIn(List<String> values) {
            addCriterion("Account_IDNO in", values, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoNotIn(List<String> values) {
            addCriterion("Account_IDNO not in", values, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoBetween(String value1, String value2) {
            addCriterion("Account_IDNO between", value1, value2, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountIdnoNotBetween(String value1, String value2) {
            addCriterion("Account_IDNO not between", value1, value2, "accountIdno");
            return (Criteria) this;
        }

        public Criteria andAccountNameIsNull() {
            addCriterion("Account_NAME is null");
            return (Criteria) this;
        }

        public Criteria andAccountNameIsNotNull() {
            addCriterion("Account_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andAccountNameEqualTo(String value) {
            addCriterion("Account_NAME =", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameNotEqualTo(String value) {
            addCriterion("Account_NAME <>", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameGreaterThan(String value) {
            addCriterion("Account_NAME >", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameGreaterThanOrEqualTo(String value) {
            addCriterion("Account_NAME >=", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameLessThan(String value) {
            addCriterion("Account_NAME <", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameLessThanOrEqualTo(String value) {
            addCriterion("Account_NAME <=", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameLike(String value) {
            addCriterion("Account_NAME like", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameNotLike(String value) {
            addCriterion("Account_NAME not like", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameIn(List<String> values) {
            addCriterion("Account_NAME in", values, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameNotIn(List<String> values) {
            addCriterion("Account_NAME not in", values, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameBetween(String value1, String value2) {
            addCriterion("Account_NAME between", value1, value2, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameNotBetween(String value1, String value2) {
            addCriterion("Account_NAME not between", value1, value2, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidIsNull() {
            addCriterion("Account_identityID is null");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidIsNotNull() {
            addCriterion("Account_identityID is not null");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidEqualTo(String value) {
            addCriterion("Account_identityID =", value, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidNotEqualTo(String value) {
            addCriterion("Account_identityID <>", value, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidGreaterThan(String value) {
            addCriterion("Account_identityID >", value, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidGreaterThanOrEqualTo(String value) {
            addCriterion("Account_identityID >=", value, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidLessThan(String value) {
            addCriterion("Account_identityID <", value, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidLessThanOrEqualTo(String value) {
            addCriterion("Account_identityID <=", value, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidLike(String value) {
            addCriterion("Account_identityID like", value, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidNotLike(String value) {
            addCriterion("Account_identityID not like", value, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidIn(List<String> values) {
            addCriterion("Account_identityID in", values, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidNotIn(List<String> values) {
            addCriterion("Account_identityID not in", values, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidBetween(String value1, String value2) {
            addCriterion("Account_identityID between", value1, value2, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccountIdentityidNotBetween(String value1, String value2) {
            addCriterion("Account_identityID not between", value1, value2, "accountIdentityid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidIsNull() {
            addCriterion("AccountTypeID is null");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidIsNotNull() {
            addCriterion("AccountTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidEqualTo(Integer value) {
            addCriterion("AccountTypeID =", value, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidNotEqualTo(Integer value) {
            addCriterion("AccountTypeID <>", value, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidGreaterThan(Integer value) {
            addCriterion("AccountTypeID >", value, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("AccountTypeID >=", value, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidLessThan(Integer value) {
            addCriterion("AccountTypeID <", value, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidLessThanOrEqualTo(Integer value) {
            addCriterion("AccountTypeID <=", value, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidIn(List<Integer> values) {
            addCriterion("AccountTypeID in", values, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidNotIn(List<Integer> values) {
            addCriterion("AccountTypeID not in", values, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidBetween(Integer value1, Integer value2) {
            addCriterion("AccountTypeID between", value1, value2, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccounttypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("AccountTypeID not between", value1, value2, "accounttypeid");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameIsNull() {
            addCriterion("Account_TYPE_NAME is null");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameIsNotNull() {
            addCriterion("Account_TYPE_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameEqualTo(String value) {
            addCriterion("Account_TYPE_NAME =", value, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameNotEqualTo(String value) {
            addCriterion("Account_TYPE_NAME <>", value, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameGreaterThan(String value) {
            addCriterion("Account_TYPE_NAME >", value, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("Account_TYPE_NAME >=", value, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameLessThan(String value) {
            addCriterion("Account_TYPE_NAME <", value, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameLessThanOrEqualTo(String value) {
            addCriterion("Account_TYPE_NAME <=", value, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameLike(String value) {
            addCriterion("Account_TYPE_NAME like", value, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameNotLike(String value) {
            addCriterion("Account_TYPE_NAME not like", value, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameIn(List<String> values) {
            addCriterion("Account_TYPE_NAME in", values, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameNotIn(List<String> values) {
            addCriterion("Account_TYPE_NAME not in", values, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameBetween(String value1, String value2) {
            addCriterion("Account_TYPE_NAME between", value1, value2, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andAccountTypeNameNotBetween(String value1, String value2) {
            addCriterion("Account_TYPE_NAME not between", value1, value2, "accountTypeName");
            return (Criteria) this;
        }

        public Criteria andContactPhoneIsNull() {
            addCriterion("Contact_Phone is null");
            return (Criteria) this;
        }

        public Criteria andContactPhoneIsNotNull() {
            addCriterion("Contact_Phone is not null");
            return (Criteria) this;
        }

        public Criteria andContactPhoneEqualTo(String value) {
            addCriterion("Contact_Phone =", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneNotEqualTo(String value) {
            addCriterion("Contact_Phone <>", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneGreaterThan(String value) {
            addCriterion("Contact_Phone >", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("Contact_Phone >=", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneLessThan(String value) {
            addCriterion("Contact_Phone <", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneLessThanOrEqualTo(String value) {
            addCriterion("Contact_Phone <=", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneLike(String value) {
            addCriterion("Contact_Phone like", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneNotLike(String value) {
            addCriterion("Contact_Phone not like", value, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneIn(List<String> values) {
            addCriterion("Contact_Phone in", values, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneNotIn(List<String> values) {
            addCriterion("Contact_Phone not in", values, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneBetween(String value1, String value2) {
            addCriterion("Contact_Phone between", value1, value2, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andContactPhoneNotBetween(String value1, String value2) {
            addCriterion("Contact_Phone not between", value1, value2, "contactPhone");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagIsNull() {
            addCriterion("is_Used_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagIsNotNull() {
            addCriterion("is_Used_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagEqualTo(Short value) {
            addCriterion("is_Used_FLAG =", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagNotEqualTo(Short value) {
            addCriterion("is_Used_FLAG <>", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagGreaterThan(Short value) {
            addCriterion("is_Used_FLAG >", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagGreaterThanOrEqualTo(Short value) {
            addCriterion("is_Used_FLAG >=", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagLessThan(Short value) {
            addCriterion("is_Used_FLAG <", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagLessThanOrEqualTo(Short value) {
            addCriterion("is_Used_FLAG <=", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagIn(List<Short> values) {
            addCriterion("is_Used_FLAG in", values, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagNotIn(List<Short> values) {
            addCriterion("is_Used_FLAG not in", values, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagBetween(Short value1, Short value2) {
            addCriterion("is_Used_FLAG between", value1, value2, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagNotBetween(Short value1, Short value2) {
            addCriterion("is_Used_FLAG not between", value1, value2, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagIsNull() {
            addCriterion("is_Default_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagIsNotNull() {
            addCriterion("is_Default_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagEqualTo(Short value) {
            addCriterion("is_Default_FLAG =", value, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagNotEqualTo(Short value) {
            addCriterion("is_Default_FLAG <>", value, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagGreaterThan(Short value) {
            addCriterion("is_Default_FLAG >", value, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagGreaterThanOrEqualTo(Short value) {
            addCriterion("is_Default_FLAG >=", value, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagLessThan(Short value) {
            addCriterion("is_Default_FLAG <", value, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagLessThanOrEqualTo(Short value) {
            addCriterion("is_Default_FLAG <=", value, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagIn(List<Short> values) {
            addCriterion("is_Default_FLAG in", values, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagNotIn(List<Short> values) {
            addCriterion("is_Default_FLAG not in", values, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagBetween(Short value1, Short value2) {
            addCriterion("is_Default_FLAG between", value1, value2, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultFlagNotBetween(Short value1, Short value2) {
            addCriterion("is_Default_FLAG not between", value1, value2, "isDefaultFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagIsNull() {
            addCriterion("run_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andRunFlagIsNotNull() {
            addCriterion("run_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andRunFlagEqualTo(Short value) {
            addCriterion("run_FLAG =", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagNotEqualTo(Short value) {
            addCriterion("run_FLAG <>", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagGreaterThan(Short value) {
            addCriterion("run_FLAG >", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagGreaterThanOrEqualTo(Short value) {
            addCriterion("run_FLAG >=", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagLessThan(Short value) {
            addCriterion("run_FLAG <", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagLessThanOrEqualTo(Short value) {
            addCriterion("run_FLAG <=", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagIn(List<Short> values) {
            addCriterion("run_FLAG in", values, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagNotIn(List<Short> values) {
            addCriterion("run_FLAG not in", values, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagBetween(Short value1, Short value2) {
            addCriterion("run_FLAG between", value1, value2, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagNotBetween(Short value1, Short value2) {
            addCriterion("run_FLAG not between", value1, value2, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunStatusIsNull() {
            addCriterion("run_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andRunStatusIsNotNull() {
            addCriterion("run_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andRunStatusEqualTo(String value) {
            addCriterion("run_STATUS =", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotEqualTo(String value) {
            addCriterion("run_STATUS <>", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusGreaterThan(String value) {
            addCriterion("run_STATUS >", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusGreaterThanOrEqualTo(String value) {
            addCriterion("run_STATUS >=", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusLessThan(String value) {
            addCriterion("run_STATUS <", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusLessThanOrEqualTo(String value) {
            addCriterion("run_STATUS <=", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusLike(String value) {
            addCriterion("run_STATUS like", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotLike(String value) {
            addCriterion("run_STATUS not like", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusIn(List<String> values) {
            addCriterion("run_STATUS in", values, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotIn(List<String> values) {
            addCriterion("run_STATUS not in", values, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusBetween(String value1, String value2) {
            addCriterion("run_STATUS between", value1, value2, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotBetween(String value1, String value2) {
            addCriterion("run_STATUS not between", value1, value2, "runStatus");
            return (Criteria) this;
        }

        public Criteria andCommentIsNull() {
            addCriterion("comment is null");
            return (Criteria) this;
        }

        public Criteria andCommentIsNotNull() {
            addCriterion("comment is not null");
            return (Criteria) this;
        }

        public Criteria andCommentEqualTo(String value) {
            addCriterion("comment =", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotEqualTo(String value) {
            addCriterion("comment <>", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThan(String value) {
            addCriterion("comment >", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThanOrEqualTo(String value) {
            addCriterion("comment >=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThan(String value) {
            addCriterion("comment <", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThanOrEqualTo(String value) {
            addCriterion("comment <=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLike(String value) {
            addCriterion("comment like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotLike(String value) {
            addCriterion("comment not like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentIn(List<String> values) {
            addCriterion("comment in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotIn(List<String> values) {
            addCriterion("comment not in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentBetween(String value1, String value2) {
            addCriterion("comment between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotBetween(String value1, String value2) {
            addCriterion("comment not between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateUseridIsNull() {
            addCriterion("create_UserID is null");
            return (Criteria) this;
        }

        public Criteria andCreateUseridIsNotNull() {
            addCriterion("create_UserID is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUseridEqualTo(Long value) {
            addCriterion("create_UserID =", value, "createUserid");
            return (Criteria) this;
        }

        public Criteria andCreateUseridNotEqualTo(Long value) {
            addCriterion("create_UserID <>", value, "createUserid");
            return (Criteria) this;
        }

        public Criteria andCreateUseridGreaterThan(Long value) {
            addCriterion("create_UserID >", value, "createUserid");
            return (Criteria) this;
        }

        public Criteria andCreateUseridGreaterThanOrEqualTo(Long value) {
            addCriterion("create_UserID >=", value, "createUserid");
            return (Criteria) this;
        }

        public Criteria andCreateUseridLessThan(Long value) {
            addCriterion("create_UserID <", value, "createUserid");
            return (Criteria) this;
        }

        public Criteria andCreateUseridLessThanOrEqualTo(Long value) {
            addCriterion("create_UserID <=", value, "createUserid");
            return (Criteria) this;
        }

        public Criteria andCreateUseridIn(List<Long> values) {
            addCriterion("create_UserID in", values, "createUserid");
            return (Criteria) this;
        }

        public Criteria andCreateUseridNotIn(List<Long> values) {
            addCriterion("create_UserID not in", values, "createUserid");
            return (Criteria) this;
        }

        public Criteria andCreateUseridBetween(Long value1, Long value2) {
            addCriterion("create_UserID between", value1, value2, "createUserid");
            return (Criteria) this;
        }

        public Criteria andCreateUseridNotBetween(Long value1, Long value2) {
            addCriterion("create_UserID not between", value1, value2, "createUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("update_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("update_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("update_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("update_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("update_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("update_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("update_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("update_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("update_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("update_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("update_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("update_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIsNull() {
            addCriterion("update_UserID is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIsNotNull() {
            addCriterion("update_UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridEqualTo(Long value) {
            addCriterion("update_UserID =", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotEqualTo(Long value) {
            addCriterion("update_UserID <>", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridGreaterThan(Long value) {
            addCriterion("update_UserID >", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridGreaterThanOrEqualTo(Long value) {
            addCriterion("update_UserID >=", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridLessThan(Long value) {
            addCriterion("update_UserID <", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridLessThanOrEqualTo(Long value) {
            addCriterion("update_UserID <=", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIn(List<Long> values) {
            addCriterion("update_UserID in", values, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotIn(List<Long> values) {
            addCriterion("update_UserID not in", values, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridBetween(Long value1, Long value2) {
            addCriterion("update_UserID between", value1, value2, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotBetween(Long value1, Long value2) {
            addCriterion("update_UserID not between", value1, value2, "updateUserid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}